play makAll work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All
HBAM2016AUG95
Pro 5.0
All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dullCopyright 1984-1996 Claris Corporation
and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy.
GIFf@
HBAM3016AUG95
HP DeskJet 540 Printer
sday!
Tuesday!
Tuesday!
Week #
Begin Week
End Week
Enter data for Time Billing
Project
Reports
7/29/1999
ACTIVITY
BEGIN WEEK
BEGIN WEEK CHECK
BILLING CHECK
CURRENT WEEK
CUSTOMER
EMAIL
DAY TYPE
DAY TYPE
DAY TYPE
DAYOFWEEKNUM7
DAYOFWEEKNUM7
DAYOFWEEKNUM7
DAYOFWEEKNUM7
DAYOFWEEKNUM7
DAYOFWEEKNUM7
DAYOFWEEKNUM7
AYOFWEEKNUM7
AYOFWEEKNUM7
AYOFWEEKNUM7
AYOFWEEKNUM7
AYOFWEEKNUM7
AYOFWEEKNUM7
AYOFWEEKNUM7
AAY NAME
TOTAL HOURS
WEEK START DAY
WORK HOURS
WORK WEEK HOURS
Begin WeekB
End WeekB
Today's DateB
End TimeB
End TimeB
Work HoursB
) +
) / 60 -
Day TypeB
Day Name 5B
+ 4)
Day Name 5B
+ 4)
Day Name 5B
+ 4)
Day Name 5B
+ 4)
Day Name 5B
+ 4)
+ 3)
Day Name 5B
+ 4)
Current WeekB
Week Start DayB
) = "Monday"
) = "Tuesday"
) = "Wednesday"
) = "Thursday"
) = "Friday"
) = "Saturday"
) = "Sunday"
- 6)
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Saturday
Sunday
Saturday
Sunday
Saturday
Sunday
Saturday
Sunday
Day Flag 1B
First NameB
Employee IDB
Today's Day NameB
Employee IDB
Today's Day NameB
Employee IDB
Today's Day NameB
Employee IDB
Today's Day NameB
Employee IDB
Today's Day NameB
Employee IDB
Today's Day NameB
Employee IDB
Today's Day NameB
Template Information GlobalB
%A Last NameB
EmailB
Mobile PhoneB
ActivityB
ActivityB
AmountB
Hours BilledB
Hours WorkedB
ProjectB
Total AmountB
Total Hours BilledB
Total Hours Worked
Information
Reports
Web List
Web Form
View - Projects Monday
Form View - Projects Sunday
Form View - Projects Sunday
Form View - Projects Sunday
Form View - Projects Sunday
Form View - Projects Sunday
Form View - Projects Sunday
cts Sunday
y Copy3
Copy3
Copy3
ListB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
DateB
2) & "-" &
Begin Week CheckB
) > "2"
"Begin week is a " &
) & "!"
Begin week is a
Billing CheckB
-)=1
"*Warning: You are billing more hours than you worked!"
5*Warning: You are billing more hours than you worked!
A$Sort by Total Hours Billed Ascending
"billedHoursA"
billedHoursA
Sort By Employee ID
5 = "employeeIDA"
employeeIDA
5 = "employeeIDD"
employeeIDD
"employeeIDA"
employeeIDA
Sort by Employee ID Descending
"employeeIDD"
employeeIDD
A&Sort by Employee First Name Descending
"firstNameD"
firstNameD
A%Sort by Employee Last Name Descending
"lastNameD"
lastNameD
Yesfter
Noarter
reeder
smith
reeder
smith
ndayT
smith
5 = "lastNameA"
lastNameA
5 = "lastNameD"
lastNameD
Pro 3.0F!
Pro 5.0N
Davo's Disk
Time Billing Line Items.fp3
dFMP3FMP3
Time Billing
YDavo's Disk:Desktop Folder:99_1_27 x11 Templates:Time Billing:Time Billing Line Items.fp3
Go to Reports Layout
Go to Information Layout
InformationB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
(LIST
LISTA!Regular
Holiday
Vacation
Sick Day
VDEFA(
dayTypes
FMRLA
Time Billing Line Items
ine Items
FMRLA
Time Billing Line Items
ne Items
FMRLA
Time Billing Line Items
ine Items
FMRLA
Time Billing Line Items
Customer Line Items Report
port
Open Script
Arial
MS Sans Serif
Helvetica
Times
Times New Roman
Geneva
Verdana
wwwwww
ffffff
UUUUUU
DDDDDD
333333
Last Name
First Name
Emp ID
Begin Week
Enter data for Employee Timecard
Hours Billed
Delete
2 Form View
3 List View
Report View
Report
Delete
Record @@ of <<
ABEE>>
ReportsB
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
T+Information about the Time Billing Template
Reports
Info for this Template
Customer
ReportI
Your Own ReportJ
Your Own
ReportK
Your Own
ReportS>Click on any of these buttons to preview the respective reportT
These sample files are provided to help you get results quickly with FileMaker Pro. You can use the files immediately by deleting the existing records and adding your own and using the provided layouts and reports. Or, you can customize the files by adding or changing fields or layouts. Click the buttons at the top to view layouts and reports.
Description
This relational database keeps track of employee hours. It is related to the Time Billing Line Items dat
abase.
How to use this template
Your employees can enter their hours directly into the database, or you can print a blank record and complete the form by hand.
The database calculates the hours worked based on the start time, lunch duration, and end time.
Tips for customizing this template
You can add fields to calculate the employees' pay, based on the hours they worked and their pay rate. You can also track vacation and sick time by adding a summary field for each time category.
EMPLOYEE ID
END WEEK
FIRST NAME
HILITEBEGINWEEK
HILITEEMPLOYEEID
HILITEFIRSTNAME
HILITELASTNAME
HILITELIBRARY
HILITESORTEDBY
HILITETOTALBILLEDHOURS
HOURS BILLED
C LAST NAME
MOBILE PHONE
TEMPLATE INFORMATION GLOBAL
TODAY'S DATE
TODAY'S DAY NAME
TOTAL AMOUNT
TOTAL HOURS BILLED
TOTAL HOURS WORKED
GIFf@
GIFf@
GIFf@
EmployeeR
Projects
First NameV Last Name
Emp. ID
Today
HiliteLibraryB
HiliteSortedByB
HiliteLastNameB
5 = "lastName"
lastName
HiliteFirstNameB
5 = "firstName"
firstName
HiliteBeginWeekB
5 = "beginWeek"
beginWeek
HiliteTotalHoursB
5 = "totalHours"
totalHours
HiliteEmployeeIDB
5 = "employeeID"
employeeID
DayOfWeekNum1B
EMPLOYEE ID
GIFf@
GIFf@
UUUUUU
wwwwww
)=400
Cancel
You did not enter any find criteria; all records will be displayed.C+
) = 0
Cancel
No records match this request.E)
A$Sort by Employee Last Name Ascending
"lastNameA"
lastNameA
Timecard Report
A%Sort by Employee First Name Ascending
"firstNameA"
firstNameA
Sort by Employee ID Ascending
"employeeIDA"
employeeIDA
Sort by Begin Week Ascending
"beginWeekA"
beginWeekA
Open Script
Close Script
Clear Sort Indicator
Go to Form Layout
Go to Information Layout
Go to List Layout
Go to Reports Layout
Sort By Employee ID
Sort By Employee First Name
Sort By Employee Last Name
Sort By Begin Week
Sort By Total Hours Billed
Sort by Employee ID Ascending
Sort by Employee ID Descending
$%Sort by Employee First Name Ascending
&&Sort by Employee First Name Descending
($Sort by Employee Last Name Ascending
*%Sort by Employee Last Name Descending
Sort by Begin Week Ascending
Sort by Begin Week Descending
0$Sort by Total Hours Billed Ascending
2&Sort by Total Hours Billed Descending
Customer Line Items Report
Your Own Report
Delete
ABEF>>
Amount
ABEG>>
Activity
Customer
Hours
Worked
Hours
Billed
Date|
Total Amount~
Total Hours Billed
Total Hours Worked
CustomerB
Hours BilledB
Total AmountB
Total Hours BilledB
Total Hours Worked
Total Hours Worked Hours Worked
Total Hours Worked
GRPTH
FPTHAGDavo's Disk:Desktop Folder:x78:Time Billing:Time Billing Line Items.fp5
MSPCA
NAMEA
Time Billing Line Items.fp5
RPTHA
Time Billing Line Items.fp5
YMSPC
FPTHAYDavo's Disk:Desktop Folder:99_1_27 x11 Templates:Time Billing:Time Billing Line Items.fp5
MSPCA
NAMEA
Time Billing Line Items.fp5
RPTHA
Time Billing Line Items.fp5
SRPTA
timeline.fp5
YMSPC
FPTHAYDavo's Disk:Desktop Folder:99_1_27 x11 Templates:Time Billing:Time Billing Line Items.fp5
MSPCA
NAMEA
Time Billing Line Items.fp5
RPTHA
Time Billing Line Items.fp5
SRPTA
timeline.fp5
Billing Line Items.fp5
SRPTA
timeline.fp5
8<>DPIA3-2@BA
LHRQ8(
#1@=0-30.,$
$*+'#
!&+-0..,-04EE<?75@@=
LHRQ73#
,-..%
'7?3/20.*&
&)33$
"&)+*'$('*-=22@CDE=8
L3RQ86/,,#
+/,)+#
19730.,*'"
'+00%
&(860<BD<:=
LHRQ741+
*342/,*''&
)"',-,$
$'0229=?37A
LHRQ41-*
$,.)#
"&$"
"')$+45-$!
1/*)-79;-.=
LHRQ2/,'$$"
$*89/$#!
#=4$'/588.(3
LHRQ0,,)$#!
").0"%$373!
)3750'+3
LHRQ.,--)#
+4?EF@"
$-/,'(),)
$,/00/
RQ.02038?<8>=63
5@FQOGCA=;=B<>7.)$!
""$',."39A>;832797*
LHRQ01204;>?=<3"$4/350#09?GEDBBC?=?@;0,("
(0,#.773.$
L.RQ133217;<:64*.'
55(%&1@CBBIJD=<81-,'()''
",10763/*
LHRQ,03149;94.,+$
8>4-(.<@AAGKEA>70.,-/+'%
',/-)$"#"
LHRQ,,/4;9850'"
)@E@937=@?ABFB>94/..0/&
',.00$
RQ&"!$.,+,,$
'AB;D98>
@-B@?=:3/.,+)"
"032.(#
2C?C9<
CD?9:80+))'$
'*//-+&"$*$4EA7-+)!
)FMB"
71'0>GC;647/*)'($
*/30,2102338HE<6/,+'
LHRQ
"@L@0
$1@G@7010'$**(%
!"$&"'0477867357;GG965330-
%0:HG:.*6DA
"-@G@70.&,%('$"
"%('&(/1220.,3;9>MQK9,07<:5
+3=DF<308@?
*;GB:32(-,#$"
"$'*'$$,'&),..29?GPQK4$#1@?<
LHRQ"
'.13$!48300
&3DD930'.,(%"
('%"!"&+..07<BIOPD3%"/BBA
LHRQ1
#,")$
,=E;/'./,'%!
'")'#
&,--06
#('+)(%!
%8JG?/32!
*626FE1
",35-"
$(,44$
LHRQ"!
"0/F<..,
/70!!
,.)#%'
*/&%9700,#
+:5""
57,$=B335)
,:6.$
*9=0#""
'291.&ID6.-,&(
'=@;(
(-<>:.++.35."
+)7=359.3G@",
.B=B3
)9@@B?<747?<7+'0672$
#,0927?DD%AE$$,
"! #1?C99C>@932BGHD>=@?:349;7,
"$&'38@>39DJKA!3"
'/577@GG@;=@<30.1>DFKGGEB??AA<5.
(8A7!
!)('*,3-0??7=GKJF3
.7,"&.13<DFECBBA4=30.9C@DKJ@@FFD@=72+
LHRQ#5A@6
)4::3,-41&,@96=KKID>0
*990+--
5=99?@;1=10.1>BJKLEBDFC>94,!
LHRQ0?BA@79@@A=81/340.9C947QKHDA?%
;=7,/.
#(.459=;0//'5>JLNGCBAA=80&
L-RQ3A@>;968@@?81143,*;=:5CQKGD??7
;97/..
/70--)'3@GHGB=>?>:/#
K=RQ.;;7537A>?@=789:3(
3IQQKDB>;@0'=821,*!
&++,..$+7=EE@
2 99
<!!NN
=##PP
>&&RR
?,,VV
@//YY
A11[[
B66^^
C;;bb
D;;aa
E??ee
F@@gg
GBBhh
HBBhh
IGGmm
JEEjj
KGGmm
LIInn
MIImm
NJJnn
OMMpp
PTTvv
QVVww
RWWxx
SYYzz
T^^~~
YTTjj
_gg{{
aii||
Web ListB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
w - Time CardsB
2/,# "%(-037<=>93007=AEJFAHGD@=."
(5=8*#6."#$().0-./,
,5AACG?;?<9742-
%(*.-/.+*297/-,29>DHGHFCA=;.")7@@;5##""#%$'*)#
'JLHEEF>29<9853/$$'+,*#
"&*$$',0;>DGDFB>;
8=@DB9*""$&""('
"(9LJGGF=25;9863.)+)'$
"$$**(.7>BEGGDA<99;>A@DF@8%0$$,#!,'#"
@KIF:..689:6-
&$'&/449<DGJJGD@==>@CFGHF@=+(' 0.
LHRQF0
!&C;'"!
,.587-
'.+'0:<ACGLNFAIFDCCDHFIKE?<89"'
L+RQ0#!"#&""#"
""(32(#*'#
",28;=:9EINQPIKKI
LK=31013$$-,)'
'@,
#/9?A7-CKNQQPONMKJJMN
KB'&&%03-1,!$($
!)7?B?4'DLN
O KHKONOPGENMHG)#"
.40/
&2<BBDD'*GL=27<G
PKMNMEC3$"
"# #%!
)7DEDCG$
IE5('$"
+9JI@@,
)78?MOI9.0@?28=4'.*(#
"$53*
& #$!
'8IH?0//"
.@?7>G=0'(-1
"!,+*10.(
!/99-
LHRQ&!
UUUUUU
wwwwww
!'/63#
$.*$%!
.5:06
LHRQ"
",64<@C=1,'&&('$&+,!
$,.-20"
!*'%"
,073=
$,12-;?>4&$"
#,-/)
&370-.)!
%.+&$&.2,
!641/2
LHRQ$#
(3:64.59:6#
"36700+"
+78/)6>95(
.+&$"
$7C:1..
LHRQ"!!
(39=><50..1.''*"
57,+.+#
2BG7&3>9:' .'(
",.7FE87D6
L RQ0'$! &*;
A;>4,.
',(&,.09@3"':>2)&*!
2@DE1;=9.&$$
/,'/63/=B=;EG3
LHRQ0'"
'(&7@@A=9&
%,,+.05<=.'6;:3030
#699C?647,+("
278720
;E?710..
LHRQ*$
%,'"'@C@=95$
",../15:=A8:756973&)0
%3;CD9BA7,'$!
%69;70/BE<44640
LHRQ#
%+$%(@D@><83
*..0177=GJD931277,%@.
.<HD=BI@7,''+,.08;671.2<7:994.
'?/CD@><95*
(../1767=B:8;40+.,
%3@@=FKIC3.0:9:<=;072+,/,+583,
*<BDFE@><973'+-,,022.26119973&(!19)
,47DKMJ@7-19:9;,9:7.('&&/:83+
LHRQ#%"
,GIFFD@=;:7420/+')'
$39=@967.).6AE.$17JKJD;/-0403<'/1"#%&'0:9:30
LHRQ""
+KKGFDA<<97431-*($#
.48AA=63007>DHK,,7IJFA:'%,339:/8."$%(,289871
BDEG@>?<973
LHRQ:996)('),$
+HB>2',&
'1677653/$
!$',4731-(
&./035>F3
MPH2,5
LHRQ=DD@837993-9H>6-+.
!(/670120'!$&&')2841/,"
"*-24<KH3&
FPN-,5
HRQ=FEHGEEDGIKKG==?0-$
$'&$)//)%"$$($
0720.+)
$-0..:=47*
7MNE.3
RQ@HHGJI
G=IJH@;GC3/1..(
".2.'$%##'**250.+')%
00+(%
"'00,
'NHQ:4
LHRQHKGCGDBBEHJB4-AC/0352' !)0.(#$$#*14740.+($(!
&(#$"
)MKNJ9
LHRQHD@>>=89@HKD3/++8>97/&&$
#$/7=830-+&"%#"
'08DIHEND
LHRQB83347339EKD4.+6DE<3.&&""*)
#..782.,'(%""
$.9DC97N
LHRQ4,'+37217@D43.,3@C93/'%
)073(('+*(#!
)6>8.9
'330:AB?40,*'$
HiliteBeginWeekB
5 = "beginWeekA"
5 = "beginWeekD"
"")
beginWeekA
beginWeekD
HiliteTotalBilledHoursB
5 = "billedHoursA"
5 = "billedHoursD"
"")
billedHoursA
billedHoursD
HiliteEmployeeIDB
5 = "employeeIDA"
5 = "employeeIDD"
"")
employeeIDA
employeeIDD
"employeeIDA"
employeeIDA
Sort by Begin Week Descending
"beginWeekD"
beginWeekD
A&Sort by Total Hours Billed Descending
"billedHoursD"
billedHoursD
Sort By Employee First Name
5 = "firstNameA"
firstNameA
5 = "firstNameD"
firstNameD
"firstNameA"
firstNameA
Sort By Employee Last Name
5 = "lastNameA"
lastNameA
5 = "lastNameD"
lastNameD
Sort By Begin Week
5 = "beginWeekA"
beginWeekA
5 = "beginWeekD"
beginWeekD
"employeeIDA"
employeeIDA
Sort By Total Hours Billed
5 = "billedHoursA"
billedHoursA
5 = "billedHoursD"
billedHoursD
"billedHoursA"
billedHoursA
Sort By Employee ID
5 = "employeeIDA"
employeeIDA
5 = "employeeIDD"
employeeIDD
"employeeIDA"
employeeIDA
Sort by Employee ID Descending
"employeeIDD"
employeeIDD
A&Sort by Employee First Name Descending
"firstNameD"
firstNameD
A%Sort by Employee Last Name Descending
"lastNameD"
lastNameD
"lastNameD"
lastNameD
Web FormB
Yesfter
Noarter
Week #
Last Name
First Name
Emp ID
Begin Week
Enter data for Employee Timecard
Hours Billed
Reports
Delete
Record @@ of <<
ABEE>>
abase.
How to use this template
Your employees can enter their hours directly into the database, or you can print a blank record and complete the form by hand.
This database calculates the hours worked, hours billed, and hourly rate for an employee, on a weekly basis.
Tips for customizing this template
You can add fields to calculate the employees' pay, based on the hours they worked and their pay rate. You can also track vacation and sick time by adding a summary field for each time cC
ategory.
Printing a Report
Click on the Reports button. Select a report to preview. Choose Print from the File menu. After printing, click the Continue button.
Clear Sort Indicator
Go to List Layout
Close Script
Your Own Report
Cancel
Create your own script and attach it to this button.